Prefixing Database Tables

Comments 0

Share to social media

Reviewing a database with 400 tables is no easy task, especially when you didn’t make the database.  It seems like it would make everyone’s life easier is if people would prefix their database tables in a way that helps group tables logically.

For example, there are tables in this 400 table database specifically used for configuring the application.  It would be nice if they were prefixed with “config_” to denote that they are configuration tables.  Instead of tables A, M, and Z intermingled with the rest of the tables in the database, they would be nicely grouped together as config_A, config_M, and config_Z

But even if everyone were to start prefixing their databases the way I want right now, it wouldn’t help me out with the one I’ve already got.  A man can dream, though … a man can dream.

Load comments

About the author

Damon Armstrong

See Profile

Damon Armstrong is a consultant with SystemwarePS in Dallas, Texas. He is also a blogger and author of Pro ASP.NET 2.0 Website Programming and SharePoint 2013 Essentials for Developers. He specializes in the Microsoft stack with a focus on web technologies like MVC, ASP.NET, JavaScript, and SharePoint. When not staying up all night coding, he can be found watching a bunch of kids, studying Biblical topics, playing golf, or recovering from staying up all night coding.